点击查询:
下面先上html页面:
Examples 约见列表
编号 约见标题 姓名 所属地区 创建时间 操作 {$vo.userid} {$vo.title} {$vo.username} {$vo.name} {$vo.pubtime|date='Y-m-d',###} 删除 {$page}
再上jquery代码:
最后上php代码:
public function search() { $title=$_POST['title']; if($title) { $moden=M('meet'); import("ORG.Util.Page"); $count= $moden->where("title='$title'")->count(); $Page= new Page($count,17); $show= $Page->show(); $sql="select userid,username,city_id,name ,title,pubtime from meet,region where title='$title' and id=city_id order by userid desc limit $Page->firstRow, $Page->listRows"; //$sql="select userid,username,city_id,name ,title,age,height,sex,telephone,education_id,professional,month_salary,weixin,pubtime from meet,region where title='$title' and id=city_id order by userid desc limit $Page->firstRow, $Page->listRows"; $rs=$moden->query($sql); if($rs) { foreach ($rs as $k => $v) { $rs[$k]['sex']=$v['sex']==1?'女':'男'; $rs[$k]['pubtime']= date('Y-m-d', $rs[$k]['pubtime']); } $json = array( 'page' => $show, 'data' => $rs ); echo json_encode($json); }else { echo '0'; } } }